DROP TABLE CRST_PO_CONTROL_RULES;

CREATE TABLE CRST_PO_CONTROL_RULES
(
CONTROL_RULE_ID        NUMBER,
CONTROL_GROUP_ID       NUMBER,
LAST_UPDATE_DATE       DATE ,
LAST_UPDATED_BY        NUMBER,
LAST_UPDATE_LOGIN      NUMBER,
CREATION_DATE          DATE ,
CREATED_BY             NUMBER,
PROGRAM_UPDATE_DATE    DATE ,
REQUEST_ID             NUMBER,
PROGRAM_APPLICATION_ID NUMBER,
PROGRAM_ID             NUMBER,
RULE_TYPE_CODE         VARCHAR (25) ,
OBJECT_CODE            VARCHAR (25) ,
AMOUNT_LIMIT           NUMBER,
LOCATION_ID            NUMBER,
SEGMENT14_HIGH         VARCHAR (40) ,
INACTIVE_DATE          DATE ,
SEGMENT12_LOW          VARCHAR (40) ,
SEGMENT12_HIGH         VARCHAR (40) ,
SEGMENT1_LOW           VARCHAR (40) ,
SEGMENT13_LOW          VARCHAR (40) ,
SEGMENT1_HIGH          VARCHAR (40) ,
SEGMENT13_HIGH         VARCHAR (40) ,
SEGMENT2_LOW           VARCHAR (40) ,
SEGMENT14_LOW          VARCHAR (40) ,
SEGMENT2_HIGH          VARCHAR (40) ,
SEGMENT3_LOW           VARCHAR (40) ,
SEGMENT15_LOW          VARCHAR (40) ,
SEGMENT3_HIGH          VARCHAR (40) ,
SEGMENT15_HIGH         VARCHAR (40) ,
SEGMENT4_LOW           VARCHAR (40) ,
SEGMENT16_LOW          VARCHAR (40) ,
SEGMENT4_HIGH          VARCHAR (40) ,
SEGMENT16_HIGH         VARCHAR (40) ,
SEGMENT5_LOW           VARCHAR (40) ,
SEGMENT17_LOW          VARCHAR (40) ,
SEGMENT5_HIGH          VARCHAR (40) ,
SEGMENT17_HIGH         VARCHAR (40) ,
SEGMENT6_LOW           VARCHAR (40) ,
SEGMENT18_LOW          VARCHAR (40) ,
SEGMENT6_HIGH          VARCHAR (40) ,
SEGMENT18_HIGH         VARCHAR (40) ,
SEGMENT7_LOW           VARCHAR (40) ,
SEGMENT19_LOW          VARCHAR (40) ,
SEGMENT7_HIGH          VARCHAR (40) ,
SEGMENT19_HIGH         VARCHAR (40) ,
SEGMENT8_LOW           VARCHAR (40) ,
SEGMENT20_LOW          VARCHAR (40) ,
SEGMENT8_HIGH          VARCHAR (40) ,
SEGMENT20_HIGH         VARCHAR (40) ,
SEGMENT9_LOW           VARCHAR (40) ,
SEGMENT21_LOW          VARCHAR (40) ,
SEGMENT9_HIGH          VARCHAR (40) ,
SEGMENT10_LOW          VARCHAR (40) ,
SEGMENT21_HIGH         VARCHAR (40) ,
SEGMENT10_HIGH         VARCHAR (40) ,
SEGMENT22_LOW          VARCHAR (40) ,
SEGMENT11_LOW          VARCHAR (40) ,
SEGMENT22_HIGH         VARCHAR (40) ,
SEGMENT11_HIGH         VARCHAR (40) ,
SEGMENT23_LOW          VARCHAR (40) ,
SEGMENT23_HIGH         VARCHAR (40) ,
SEGMENT24_LOW          VARCHAR (40) ,
SEGMENT24_HIGH         VARCHAR (40) ,
SEGMENT25_LOW          VARCHAR (40) ,
SEGMENT25_HIGH         VARCHAR (40) ,
SEGMENT26_LOW          VARCHAR (40) ,
SEGMENT26_HIGH         VARCHAR (40) ,
SEGMENT27_LOW          VARCHAR (40) ,
SEGMENT27_HIGH         VARCHAR (40) ,
SEGMENT28_LOW          VARCHAR (40) ,
SEGMENT28_HIGH         VARCHAR (40) ,
SEGMENT29_LOW          VARCHAR (40) ,
SEGMENT29_HIGH         VARCHAR (40) ,
SEGMENT30_LOW          VARCHAR (40) ,
SEGMENT30_HIGH         VARCHAR (40) ,
ATTRIBUTE1             VARCHAR (150) ,
ATTRIBUTE2             VARCHAR (150) ,
ATTRIBUTE3             VARCHAR (150) ,
ATTRIBUTE4             VARCHAR (150) ,
ATTRIBUTE5             VARCHAR (150) ,
ATTRIBUTE6             VARCHAR (150) ,
ATTRIBUTE7             VARCHAR (150) ,
ATTRIBUTE8             VARCHAR (150) ,
ATTRIBUTE9             VARCHAR (150) ,
ATTRIBUTE10            VARCHAR (150) ,
ATTRIBUTE11            VARCHAR (150) ,
ATTRIBUTE12            VARCHAR (150) ,
ATTRIBUTE13            VARCHAR (150) ,
ATTRIBUTE14            VARCHAR (150) ,
ATTRIBUTE15            VARCHAR (150) ,
ATTRIBUTE_CATEGORY     VARCHAR (30) 
);
